package cn.dravenxiaokai.excel;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import java.io.File;

public class JxlExpExcel {
    /**
     * JXL创建excel文件
     *
     * @param args
     */
    public static void main(String[] args) {
        // 用数组存表头
        String[] title = {"id", "name", "sex"};
        // 创建Excel文件
        File file = new File("d:/output/jxl_test.xls");
        try {
            file.createNewFile();
//            创建工作簿
            WritableWorkbook workbook = Workbook.createWorkbook(file);
//            创建sheet
            WritableSheet sheet = workbook.createSheet("sheet1", 0);
            Label label = null;

            // 第一行设置列名
            for (int i = 0; i < title.length; i++) {
                label = new Label(i, 0, title[i]);
                sheet.addCell(label);
            }

            // 追加数据
            for (int i = 1; i < 10; i++) {
                label = new Label(0, i, "a" + 1);
                sheet.addCell(label);
                label = new Label(1, i, "user" + 1);
                sheet.addCell(label);
                label = new Label(2, i, "男");
                sheet.addCell(label);
            }

            // 写入数据
            workbook.write();
            workbook.close();


        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}
